USE [Capstone]
GO

/****** Object:  StoredProcedure [dbo].[SystemDefault_Save]    Script Date: 07/22/2012 22:54:19 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

  
-- =============================================  
-- Author:  Peter Gamble  
-- Create date: 04/08/2009  
-- Description: Return Bit - Username Exists?  
-- =============================================  
Create PROCEDURE [dbo].[SystemDefault_Save]   
 -- Add the parameters for the stored procedure here  
@eFieldName varchar(200),
@eFieldKey nvarchar(2000),
@eFieldType varchar(200),
@eFieldDesc nvarchar(200)  
AS  
BEGIN  
 -- SET NOCOUNT ON added to prevent extra result sets from  
 -- interfering with SELECT statements.  
 SET NOCOUNT ON;  
Declare 
 @iFieldName varchar(200), 
 @iFieldKey nvarchar(2000), 
 @iFieldType varchar(200), 
 @iFieldDesc nvarchar(200);  

SET @iFieldName  = @eFieldName;
SET @iFieldKey = @eFieldKey;
SET @iFieldType = @eFieldType;
SET @iFieldDesc = @eFieldDesc;  
  
    -- Insert statements for procedure here  
insert into SystemDefaultValues
 (Field_Name, Field_Key, Field_Type, Field_Description)
  values
 (@iFieldName, @iFieldKey, @iFieldType, @iFieldDesc)
END  
  
GO

